Tabela PhStOrder

Definicja tabeli PhStOrder

Name

PhStOrder

Code

PhStOrder

Comment

Zamówienia wewnetrzne


Lista kolumn tabeli PhStOrder

Name

Code

StOrderID

StOrderID

StOrderTypeID

StOrderTypeID

StOrderStatusID

StOrderStatusID

RelatedStOrderID

RelatedStOrderID

StockOrderApprovalID

StockOrderApprovalID

RealizationDT

RealizationDT

Cito

Cito

Info

Info

UserID

UserID

StOrderDT

StOrderDT

StOrderNumber

StOrderNumber

SourceStID

SourceStID

DestinationStID

DestinationStID

OrgUnitID

OrgUnitID

Active

Active

CommissionID

CommissionID

AcceptationDT

AcceptationDT

DirectorateApprovalNo

DirectorateApprovalNo

IsGivenToPatient

IsGivenToPatient

GivenDaysAmount

GivenDaysAmount

LastDeliveryDT

LastDeliveryDT

Version

Version

DestinationStPlaceID

DestinationStPlaceID

RefuseReason

RefuseReason

StOrderKindID

StOrderKindID

StartDT

StartDT

StopDT

StopDT

ExternalNo

ExternalNo

StOrderSourceID

StOrderSourceID

StOrderPriorityID

StOrderPriorityID

StOrderPriorityName

StOrderPriorityName

OccurrenceDT

OccurrenceDT


Kolumna StOrderID tabeli PhStOrder

Definicja kolumny StOrderID tabeli PhStOrder

Name

StOrderID

Code

StOrderID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StOrderTypeID tabeli PhStOrder

Definicja kolumny StOrderTypeID tabeli PhStOrder

Name

StOrderTypeID

Code

StOrderTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StOrderStatusID tabeli PhStOrder

Definicja kolumny StOrderStatusID tabeli PhStOrder

Name

StOrderStatusID

Code

StOrderStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna RelatedStOrderID tabeli PhStOrder

Definicja kolumny RelatedStOrderID tabeli PhStOrder

Name

RelatedStOrderID

Code

RelatedStOrderID

Data Type

NUMBER(10)

Mandatory

No

Comment

Klucz wlasny mówiacy o stworzeniu zamówienia do Apteki centralnej na podstawie danego zlecenia leku na pacjenta.


Kolumna StockOrderApprovalID tabeli PhStOrder

Definicja kolumny StockOrderApprovalID tabeli PhStOrder

Name

StockOrderApprovalID

Code

StockOrderApprovalID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RealizationDT tabeli PhStOrder

Definicja kolumny RealizationDT tabeli PhStOrder

Name

RealizationDT

Code

RealizationDT

Data Type

DATE

Mandatory

No

Comment

Data realizacji


Kolumna Cito tabeli PhStOrder

Definicja kolumny Cito tabeli PhStOrder

Name

Cito

Code

Cito

Data Type

NUMBER(3)

Mandatory

No

Comment

Zamówienie CITO


Kolumna Info tabeli PhStOrder

Definicja kolumny Info tabeli PhStOrder

Name

Info

Code

Info

Data Type

VARCHAR2(4000)

Mandatory

No

Comment

Info


Kolumna UserID tabeli PhStOrder

Definicja kolumny UserID tabeli PhStOrder

Name

UserID

Code

UserID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID uzytkownika


Kolumna StOrderDT tabeli PhStOrder

Definicja kolumny StOrderDT tabeli PhStOrder

Name

StOrderDT

Code

StOrderDT

Data Type

DATE

Mandatory

No

Comment

Data zamówienia wewnetrznego


Kolumna StOrderNumber tabeli PhStOrder

Definicja kolumny StOrderNumber tabeli PhStOrder

Name

StOrderNumber

Code

StOrderNumber

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

Numer zamówienia wewnetrznego


Kolumna SourceStID tabeli PhStOrder

Definicja kolumny SourceStID tabeli PhStOrder

Name

SourceStID

Code

SourceStID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID magazynu – zródla zamówienia


Kolumna DestinationStID tabeli PhStOrder

Definicja kolumny DestinationStID tabeli PhStOrder

Name

DestinationStID

Code

DestinationStID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID magazynu – realizujacego zamówienie


Kolumna OrgUnitID tabeli PhStOrder

Definicja kolumny OrgUnitID tabeli PhStOrder

Name

OrgUnitID

Code

OrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID jednostki organizacyjnej


Kolumna Active tabeli PhStOrder

Definicja kolumny Active tabeli PhStOrder

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w systemie


Kolumna CommissionID tabeli PhStOrder

Definicja kolumny CommissionID tabeli PhStOrder

Name

CommissionID

Code

CommissionID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID zlecenia zewnetrznego


Kolumna AcceptationDT tabeli PhStOrder

Definicja kolumny AcceptationDT tabeli PhStOrder

Name

AcceptationDT

Code

AcceptationDT

Data Type

DATE

Mandatory

No

Comment

Data akceptacji zamówienia


Kolumna DirectorateApprovalNo tabeli PhStOrder

Definicja kolumny DirectorateApprovalNo tabeli PhStOrder

Name

DirectorateApprovalNo

Code

DirectorateApprovalNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer akceptacji zamówienia


Kolumna IsGivenToPatient tabeli PhStOrder

Definicja kolumny IsGivenToPatient tabeli PhStOrder

Name

IsGivenToPatient

Code

IsGivenToPatient

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Czy lek zostal wydany pacjentowi do domu


Kolumna GivenDaysAmount tabeli PhStOrder

Definicja kolumny GivenDaysAmount tabeli PhStOrder

Name

GivenDaysAmount

Code

GivenDaysAmount

Data Type

NUMBER(10)

Mandatory

No

Comment

Ilosc dni, na które lek zostal wydany pacjentowi do domu


Kolumna LastDeliveryDT tabeli PhStOrder

Definicja kolumny LastDeliveryDT tabeli PhStOrder

Name

LastDeliveryDT

Code

LastDeliveryDT

Data Type

DATE

Mandatory

No

Comment

Pole sluzace do zapisu ostatniej daty wydania


Kolumna Version tabeli PhStOrder

Definicja kolumny Version tabeli PhStOrder

Name

Version

Code

Version

Data Type

NUMBER(10)

Mandatory

Yes

Comment

wersja obiektu do zarzadzania wielowatkowym


Kolumna DestinationStPlaceID tabeli PhStOrder

Definicja kolumny DestinationStPlaceID tabeli PhStOrder

Name

DestinationStPlaceID

Code

DestinationStPlaceID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kolumna wskazuje docelowe miejsce skladowania dla zamówienia z oddzialu


Kolumna RefuseReason tabeli PhStOrder

Definicja kolumny RefuseReason tabeli PhStOrder

Name

RefuseReason

Code

RefuseReason

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Przyczyna odmowy przyjecia leku


Kolumna StOrderKindID tabeli PhStOrder

Definicja kolumny StOrderKindID tabeli PhStOrder

Name

StOrderKindID

Code

StOrderKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli PhStOrder

Definicja kolumny StartDT tabeli PhStOrder

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

zamówienie/zlecenie obowiazujace od


Kolumna StopDT tabeli PhStOrder

Definicja kolumny StopDT tabeli PhStOrder

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

zamówienie/zlecenie obowiazujace do


Kolumna ExternalNo tabeli PhStOrder

Definicja kolumny ExternalNo tabeli PhStOrder

Name

ExternalNo

Code

ExternalNo

Data Type

VARCHAR2(50)

Mandatory

No

Comment

numer zamówienia z systemu zewnetrznego


Kolumna StOrderSourceID tabeli PhStOrder

Definicja kolumny StOrderSourceID tabeli PhStOrder

Name

StOrderSourceID

Code

StOrderSourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

id systemu zewnetrznego


Kolumna StOrderPriorityID tabeli PhStOrder

Definicja kolumny StOrderPriorityID tabeli PhStOrder

Name

StOrderPriorityID

Code

StOrderPriorityID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID priorytetu


Kolumna StOrderPriorityName tabeli PhStOrder

Definicja kolumny StOrderPriorityName tabeli PhStOrder

Name

StOrderPriorityName

Code

StOrderPriorityName

Data Type

VARCHAR2(30)

Mandatory

No

Comment

Nazwa prioritetu


Kolumna OccurrenceDT tabeli PhStOrder

Definicja kolumny OccurrenceDT tabeli PhStOrder

Name

OccurrenceDT

Code

OccurrenceDT

Data Type

DATE

Mandatory

No

Comment

Kolumna ma sluzyc do zapisu daty, na która ma byc tworzone zamówienie.


Lista kluczy tabeli PhStOrder

Name

Code

Primary

Key_1

Key_1

X


Klucz Key_1 tabeli PhStOrder

Definicja klucza Key_1 tabeli PhStOrder

Name

Key_1

Code

Key_1

Primary

Yes

Comment